[dbo].[BAEImisProductKitGetAllChildren]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisProductKitGetAllChildren

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ParentProductCode	varchar(31)	31

SQL Script

create procedure [dbo].[BAEImisProductKitGetAllChildren] @ParentProductCode as
varchar(31)
AS
    SELECT *
    FROM OrderProduct AS op JOIN Product_Kit AS pk ON op.ProductCode COLLATE database_default = pk.ITEM_PRODUCT_CODE COLLATE database_default
    WHERE pk.PRODUCT_CODE = @ParentProductCode;

GO

Uses

[dbo].[OrderProduct]
[dbo].[Product_Kit]
dbo